Prerequisites

The following section describes the prerequisites for working with the Qlik Replicate SAP ODP endpoint.

ODP API

The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:

• PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)

• PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)

• PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)

• SAP_BW 750 SP 0 (incl. former PI_BASIS packages)

For more information, see SAP Note 1931427.

For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.

SAP Java Connector

To work with the SAP ODP endpoint, you need to install SAP Java Connector on the Replicate server.

Installing the SAP Java Connector on Replicate for Windows

To install the SAP Java Connector:

1. Download the SAP Java Connector 3.x (64-bit) for Windows from the SAP Support Portal.

   To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.

   Information note

   The SAP Java Connector 3.1 running on Windows operating systems requires the Microsoft Visual Studio 2013 C/C++ runtime libraries to be installed on the system. See SAP Note 2786882 for details.

2. Install the SAP Java Connector.

3. Copy the Sapjco3.jar and Sapjco3.dll files from the SAP Java Connector installation folder to the following location under the Replicate installation directory:

   {REPLICATE_INSTALL_DIR}\endpoint_srv\endpoints\SAPOdp.

4. Restart all of the Replicate services.
   Information noteIf SAP Extractor is already installed, move the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>\endpoint_srv\externals to <REPLICATE_INSTALL_DIR>\endpoint_srv\endpoints\SAPOdp and restart all of the Replicate services.

Installing the SAP Java Connector on Replicate for Linux

To install the SAP Java Connector:

1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

2. Download the SAP Java Connector 3.x (64-bit) for Linux from the SAP Support Portal.

   To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.

3. Unzip the file you downloaded to a folder of your choice.

   The folder should contain the Sapjco3.jar and libsapjco3.so files.

4. Copy these files to the following location under the Replicate installation directory:

   <INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp.

6. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.

Information note

If SAP Extractor is already installed, copy the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>/endpoint_srv/externals to the following locations:

• <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp
• <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAP

Then restart all of the Replicate services as described in Replicate server procedures.

STXL table support

To expose the table STXL for extraction using the SAP ODP endpoint, a custom extractor needs to be created in transaction RSO2 in SAP GUI. This extractor can then be called by the SAP ODP endpoint.

Setting up SLT on SAP

In order to replicate data, you must first define the parameters that SAP Landscape Transformation Replication Server will use to replicate data from a source system to a target system. You specify this information in a configuration. A configuration contains information about the source system, the target system, and the relevant connections.

You create a configuration in SAP Landscape Transformation Replication Server system. To create a configuration, open the SAP LT Replication Server Cockpit (transaction LTRC) and choose Create Configuration.

Creating a configuration involves the following steps:

1. In the Specify General Data tab, provide the following information:

   • Configuration Name: You must specify a name for the configuration. This name is used for the schema that is created automatically in the target system.

   • Description (Optional): Optionally, specify a description for the configuration.

2. In the Specify Source System tab, select the RFC Connection option and provide the following information:

   • RFC Destination: Enter NONE.
   • Allow Multiple Usage: Select this option.

3. In the Specify Target System tab, select the Other option and provide the following information:

   • Scenario: Select Operational Data Provisioning (ODP) from the drop-down list.
   • Queue Alias: Specify a name.

4. In the Specify Transfer Settings tab, specify transfer settings appropriate for your environment. Under Job Options, we recommend setting at least five Data Transfer, Initial Load, and Calculation Jobs.

5. In the Review and Create tab, review your settings and create the configuration.

6. Grant the Required permissions.

Once you have created a configuration, you can then proceed to configure the relevant settings in the Advanced tab. See Setting advanced properties for details.